package tb4coding.sprider4lagou.dao;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;

import tb4coding.sprider4lagou.pojo.Detail;
import tb4coding.sprider4lagou.pojo.Result;

public interface IResultDao {
/*	@Insert(" insert into tb_position_catalog"
			+ " (companyId,positionName,positionType,workYear,education,jobNature,createTime,companyShortName,city,positionFirstType,positionId,salary,positionAdvantage,companyName,companyLogo,industryField,financeStage,companyLabelList,deliverCount,leaderName,companySize,score,imstate,hrScore,createTimeSort,positonTypesMap,flowScore,showCount,pvScore,plus,adjustScore,relScore,formatCreateTime,countAdjusted,randomScore,calcScore,orderBy,showOrder,haveDeliver,adWord,totalCount,searchScore) "
			+ "values "
			+ "(#{companyId},#{positionName},#{positionType},#{workYear},#{education},#{jobNature},#{createTime},#{companyShortName},#{city},#{positionFirstType},#{positionId},#{salary},#{positionAdvantage},#{companyName},#{companyLogo},#{industryField},#{financeStage},#{companyLabelList},#{deliverCount},#{leaderName},#{companySize},#{score},#{imstate},#{hrScore},#{createTimeSort},#{positonTypesMap},#{flowScore},#{showCount},#{pvScore},#{plus},#{adjustScore},#{relScore},#{formatCreateTime},#{countAdjusted},#{randomScore},#{calcScore},#{orderBy},#{showOrder},#{haveDeliver},#{adWord},#{totalCount},#{searchScore})")
*/	
	@Insert(" insert into tb_position_catalog"
			+ " (companyId,positionName,positionType,workYear,education,jobNature,createTime,companyShortName,city,positionFirstType,positionId,salary,positionAdvantage,companyName,companyLogo,industryField,financeStage,deliverCount,leaderName,companySize,score,imstate,hrScore,createTimeSort,positonTypesMap,flowScore,showCount,pvScore,plus,adjustScore,relScore,formatCreateTime,countAdjusted,randomScore,calcScore,orderBy,showOrder,haveDeliver,adWord,totalCount,searchScore) "
			+ "values "
			+ "(#{companyId},#{positionName},#{positionType},#{workYear},#{education},#{jobNature},#{createTime},#{companyShortName},#{city},#{positionFirstType},#{positionId},#{salary},#{positionAdvantage},#{companyName},#{companyLogo},#{industryField},#{financeStage},#{deliverCount},#{leaderName},#{companySize},#{score},#{imstate},#{hrScore},#{createTimeSort},#{positonTypesMap},#{flowScore},#{showCount},#{pvScore},#{plus},#{adjustScore},#{relScore},#{formatCreateTime},#{countAdjusted},#{randomScore},#{calcScore},#{orderBy},#{showOrder},#{haveDeliver},#{adWord},#{totalCount},#{searchScore})")
	@Options(useGeneratedKeys=true, keyProperty="id")
	void add(Result result);
	
	@Select("select positionId from tb_position_catalog")
	List<String> getIdList();
	
	@Insert("insert into tb_position_catalog (position_id,describe,address,temptation) values (#{positionId},#{describe},#{address},#{temptation})")
	void addDetails(Detail detail);
}
